Plotting murder by year
- “cases_avg” represents the average between precincts 43, 47, and
49
Among selected precincts (based on initial discussions)
Among likely control precincts
Slopes of murder across year for each precinct
- Find similar slopes to “case_avg”
|
PCT
|
slope
|
|
79
|
-0.6415584
|
|
75
|
-0.6064935
|
|
83
|
-0.5909091
|
|
81
|
-0.5727273
|
|
71
|
-0.5467532
|
|
67
|
-0.5142857
|
|
73
|
-0.5038961
|
|
103
|
-0.4363636
|
|
113
|
-0.3116883
|
|
105
|
-0.2688312
|
|
70
|
-0.2389610
|
|
32
|
-0.2155844
|
|
60
|
-0.2064935
|
|
72
|
-0.2012987
|
|
30
|
-0.1870130
|
|
63
|
-0.1857143
|
|
46
|
-0.1805195
|
|
61
|
-0.1779221
|
|
28
|
-0.1701299
|
|
108
|
-0.1350649
|
|
52
|
-0.1311688
|
|
106
|
-0.1272727
|
|
7
|
-0.1233766
|
|
26
|
-0.1220779
|
|
23
|
-0.1207792
|
|
cases_avg
|
-0.1194805
|
|
110
|
-0.1181818
|
|
69
|
-0.1142857
|
|
104
|
-0.1142857
|
|
112
|
-0.1116883
|
|
50
|
-0.1090909
|
|
10
|
-0.1077922
|
|
109
|
-0.1051948
|
|
101
|
-0.0831169
|
|
6
|
-0.0792208
|
|
107
|
-0.0779221
|
|
90
|
-0.0675325
|
|
114
|
-0.0610390
|
|
33
|
-0.0584416
|
|
44
|
-0.0584416
|
|
42
|
-0.0545455
|
|
94
|
-0.0532468
|
|
45
|
-0.0519481
|
|
62
|
-0.0519481
|
|
66
|
-0.0467532
|
|
13
|
-0.0311688
|
|
76
|
-0.0298701
|
|
19
|
-0.0207792
|
|
100
|
-0.0207792
|
|
24
|
-0.0168831
|
|
20
|
-0.0077922
|
|
123
|
-0.0051948
|
|
68
|
0.0025974
|
|
102
|
0.0077922
|
|
41
|
0.0090909
|
|
25
|
0.0129870
|
|
40
|
0.0142857
|
|
18
|
0.0207792
|
|
34
|
0.0233766
|
|
111
|
0.0337662
|
|
115
|
0.0337662
|
|
9
|
0.0337662
|
|
84
|
0.0415584
|
|
17
|
0.0428571
|
|
1
|
0.0558442
|
|
48
|
0.0831169
|
|
5
|
0.1116883
|
|
14
|
0.1714286
|
Plotting shootings by year
- “case_avg” represents the average between precincts 43, 47, and
49
Among selected precincts (based on initial discussions)
Slopes of shootings across year for each precinct
- Find similar slopes to “case_avg”
|
PCT
|
slope
|
|
79
|
-3.1768382
|
|
67
|
-2.9408261
|
|
73
|
-2.8964945
|
|
75
|
-2.7065716
|
|
81
|
-2.2624744
|
|
113
|
-2.1291866
|
|
83
|
-1.8559711
|
|
71
|
-1.6799141
|
|
103
|
-1.1371936
|
|
70
|
-1.1279172
|
|
105
|
-0.9938483
|
|
cases_avg
|
-0.9109787
|
|
101
|
-0.8298994
|
|
41
|
-0.7710185
|
|
32
|
-0.7219022
|
|
52
|
-0.6909481
|
|
63
|
-0.6427107
|
|
60
|
-0.6121473
|
|
30
|
-0.4612831
|
|
23
|
-0.4539596
|
|
42
|
-0.4199785
|
|
40
|
-0.4083586
|
|
90
|
-0.3843375
|
|
69
|
-0.3723269
|
|
61
|
-0.3480129
|
|
33
|
-0.3303388
|
|
106
|
-0.2635485
|
|
10
|
-0.2498779
|
|
28
|
-0.2026169
|
|
76
|
-0.1703935
|
|
100
|
-0.1554536
|
|
26
|
-0.1489112
|
|
46
|
-0.1445171
|
|
24
|
-0.1412948
|
|
104
|
-0.1365101
|
|
112
|
-0.1252807
|
|
62
|
-0.1194219
|
|
110
|
-0.1162972
|
|
109
|
-0.1142467
|
|
6
|
-0.1098526
|
|
66
|
-0.0682551
|
|
45
|
-0.0503857
|
|
123
|
-0.0436481
|
|
115
|
-0.0369105
|
|
13
|
-0.0165023
|
|
68
|
-0.0105458
|
|
17
|
0.0130847
|
|
50
|
0.0197246
|
|
1
|
0.0235329
|
|
94
|
0.0266576
|
|
72
|
0.0342740
|
|
7
|
0.0405234
|
|
107
|
0.0476516
|
|
48
|
0.0510692
|
|
84
|
0.0580998
|
|
25
|
0.0714774
|
|
9
|
0.0844644
|
|
111
|
0.0901279
|
|
5
|
0.1055561
|
|
44
|
0.1064349
|
|
20
|
0.1201055
|
|
18
|
0.1324089
|
|
19
|
0.1836735
|
|
114
|
0.1934381
|
|
108
|
0.1980275
|
|
102
|
0.2875696
|
|
14
|
0.3834586
|
|
34
|
1.0368128
|